package com.ultrasoft.farmasoft.repository;

import java.util.List;


import com.ultrasoft.farmasoft.domain.Product;

public interface ProductDao {
	public List<Product> getListProduct();
	public List<Product> getListProduct(boolean active);
	public List<Product> getListProductByActiveSubstanceIdByActive(Integer activeSubstanceId,boolean active);
	public List<Product> getListProductByActiveSubstanceId(Integer activeSubstanceId);
	public List<Product> getListProductByActiveByName(boolean active,String name);
	public List<Product> getListProductByActiveByCode(boolean active,String code);
	public List<Product> getListProductByActiveByCodeBar(boolean active,String codeBar);
	public List<Product> getListProductByproviderIdByActiveByName(Integer providerId,boolean active,String name);
	public List<Product> getListProductByproviderIdByActiveByCode(Integer providerId,boolean active,String code);
	public List<Product> getListProductByproviderIdByActiveByCodeBar(Integer providerId,boolean active,String codeBar);
	public List<Product> getListProductByproviderId(Integer providerId);
	public List<Product> getListProductByproviderId(Integer providerId,boolean active);
	public List<Product> getListProductByproductId(Integer productId);
	public List<Product> getListProductByproductId(Integer productId,boolean active);
	public Product findByProviderIdByProductId(Integer providerId,Integer productId);				
    public void update(Product product);
	public void add(Product product);
	public Integer findByProductIdMax();
	//public List<Product> lista();
	public List<Object[]> getListObjectProductByStatePackageByStateItem();	
}
